﻿using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;

public partial class InventoryTracker_LGView : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    
    protected void btnDelete_Click(object sender, EventArgs e)
    {
        String SelectValue = DdlInvNo.SelectedValue;
        string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        SqlConnection con = new SqlConnection(constr);
        con.Open();
        String sql = "DELETE FROM  InvoiceDetails WHERE  [InvoiceNumber]=" + SelectValue;
        SqlCommand cmd = new SqlCommand(sql, con);
        cmd.ExecuteNonQuery();
        con.Close();
    }
    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        String SelectValue = DdlInvNo.SelectedValue;
        string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
        SqlConnection con = new SqlConnection(constr);
        con.Open();
        String sql = "UPDATE InvoiceDetails SET InvoiceItem=@InvoiceItem,ItemDescription=@ItemDescription,InvoiceItemRate=@InvoiceItemRate,InvoiceItemQty=@InvoiceItemQty,InvoiceTotalAmount=@InvoiceTotalAmount WHERE  [InvoiceNumber]=" + SelectValue;
        SqlCommand cmd = new SqlCommand(sql, con);
        cmd.ExecuteNonQuery();
        con.Close();
    }
}
